{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Web form","Options"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Web form","index":0,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["SabreCom-300 System option selector and part number configurator",null,"v2.1","2024-09-03",null,"Hide","Hide","Hide","Hide","Hide"]
["Click yellow cell. Then click arrow that appears to the right to choose an option.",null,null,null,null,"for","for","for","for","for"]
["Options with * are considered \"default\" options.",null,null,null,null,"Customer","Customer","Customer","Customer","Customer"]
["Part number and part description text will automatically fill in based on your selections.",null,null,null,null,"Use","Use","Use","Use","Use"]
["All options must be selected to generate a valid configuration and part number."]
["Then submit this configuration worksheet to the email address below for a quote or further discussion with our technical sales team."]
["sales@diamondsystems.com"]
[null,null,null,"Part number builder text","Part description builder text","Cost","Margin","Price"]
["Base model (no selection required)",null,null,"SC300-","SabreCom-300, ",1000,0.65,{"$f":"ROUND(F9/(1-G9),0)","v":2857}]
[]
[{"$f":"Options!A1","v":"SBC"},"Venus 776KL-20",null,{"$f":"VLOOKUP(B11,Options!A:C,2,FALSE)","v":"VNS776-20"},{"$f":"VLOOKUP(B11,Options!A:C,3,FALSE)","v":"i7-7600U CPU, 20GB RAM, "},{"$f":"VLOOKUP(B11,Options!A:F,4,FALSE)","v":1200},{"$f":"VLOOKUP(B11,Options!A:F,5,FALSE)","v":0.55000000000000004},{"$f":"VLOOKUP(B11,Options!A:F,6,FALSE)","v":2667}]
[]
[{"$f":"Options!G1","v":"Operating system"},"*Linux 64-bit",null,{"$f":"VLOOKUP(B13,Options!G:I,2,FALSE)","v":"-LNX"},{"$f":"VLOOKUP(B13,Options!G:I,3,FALSE)","v":"Linux, "},{"$f":"VLOOKUP(B13,Options!G:L,4,FALSE)","v":75},{"$f":"VLOOKUP(B13,Options!G:L,5,FALSE)","v":0.5},{"$f":"VLOOKUP(B13,Options!G:L,6,FALSE)","v":150}]
[]
[{"$f":"Options!M1","v":"Ethernet switch"},"8 Gbe copper ports",null,{"$f":"VLOOKUP(B15,Options!M:O,2,FALSE)","v":"-EG8"},{"$f":"VLOOKUP(B15,Options!M:R,3,FALSE)","v":"8-Port Gbe Switch, "},{"$f":"VLOOKUP(B15,Options!M:R,4,FALSE)","v":191},{"$f":"VLOOKUP(B15,Options!M:R,5,FALSE)","v":0.55000000000000004},{"$f":"VLOOKUP(B15,Options!M:R,6,FALSE)","v":424}]
[]
[{"$f":"Options!S1","v":"Switch firmware"},"Webstax Layer 2+",null,{"$f":"VLOOKUP(B17,Options!S:X,2,FALSE)","v":"-L2"},{"$f":"VLOOKUP($B17,Options!$S:$X,3,FALSE)","v":"Layer 2+ FW, "},{"$f":"VLOOKUP($B17,Options!$S:$X,4,FALSE)","v":0},{"$f":"VLOOKUP($B17,Options!$S:$X,5,FALSE)","v":0.45},{"$f":"VLOOKUP($B17,Options!$S:$X,6,FALSE)","v":0}]
[]
[{"$f":"Options!Y1","v":"Power supply"},"*MIL with isolation",null,{"$f":"VLOOKUP(B19,Options!Y:AD,2,FALSE)","v":"-J"},{"$f":"VLOOKUP(B19,Options!Y:AD,3,FALSE)","v":"MIL Iso Power, "},{"$f":"VLOOKUP(B19,Options!Y:AD,4,FALSE)","v":964},{"$f":"VLOOKUP(B19,Options!Y:AD,5,FALSE)","v":0.5},{"$f":"VLOOKUP(B19,Options!Y:AD,6,FALSE)","v":1928}]
[]
[{"$f":"Options!AE1","v":"Integrated mass storage"},"512GB",null,{"$f":"VLOOKUP(B21,Options!AE:AJ,2,FALSE)","v":"5"},{"$f":"VLOOKUP(B21,Options!AE:AJ,3,FALSE)","v":"512GB SSD"},{"$f":"VLOOKUP(B21,Options!AE:AJ,4,FALSE)","v":76},{"$f":"VLOOKUP(B21,Options!AE:AJ,5,FALSE)","v":0.5},{"$f":"VLOOKUP(B21,Options!AE:AJ,6,FALSE)","v":152}]
[]
[{"$f":"Options!AK1","v":"Expansion I/O"},"*My system has no additional I/O requirements",null,{"$f":"VLOOKUP(B23,Options!AK:AM,2,FALSE)","v":"-01"},{"$f":"VLOOKUP(B23,Options!AK:AM,3,FALSE)","v":""},0,0.5,{"$f":"F23/(1-G23)","v":0},"Enter total cost for custom I/O"]
[null,null,null,null,null,null,null,null,"in green cell (boards + cables)"]
[null,"<Enter additional I/O details here. Cell will expand as needed.>",null,null,null,{"$f":"IF(B15=Options!M3,'Web form'!F45,IF('Web form'!B15=Options!M4,'Web form'!F44,'Web form'!F46))","v":1512},0.5,{"$f":"ROUND(F25/(1-G25),0)","v":3024},"Internal cables"]
[]
["Your system part number:",{"$f":"_xlfn.CONCAT(D9:D23)","v":"SC300-VNS776-20-LNX-EG8-L2-J5-01"},null,null,null,200,null,400,"Assembly / test labor"]
["Your system description:",{"$f":"_xlfn.CONCAT(E9:E23)","v":"SabreCom-300, i7-7600U CPU, 20GB RAM, Linux, 8-Port Gbe Switch, Layer 2+ FW, MIL Iso Power, 512GB SSD"},null,null,null,{"$f":"SUM(F9:F27)","v":5218},null,{"$f":"SUM(H9:H27)","v":11602},"Calculated price"]
[null,null,null,null,null,"BOM cost",null,1000,"Bonus"]
[null,null,null,null,null,null,null,{"$f":"MROUND(H29+H28,50)","v":12600},"Qty 1 price end user"]
[null,null,null,null,null,null,null,{"$f":"H30-F28","v":7382},"Margin $"]
[null,null,null,null,null,null,null,{"$f":"H31/H30","v":0.58587301587301588},"Margin %"]
[null,null,null,null,null,null,null,{"$f":"LEN(B28)","v":101},"Description length"]
[]
[null,null,null,null,null,"Cables",null,null,6,10]
[null,null,null,null,null,"Est cost","Description","Conn cost","Pins","Cables"]
[null,null,null,null,null,{"$f":"H37+I37*$I$35+J37*$J$35","v":84},"Power in",50,4,1]
[null,null,null,null,null,534,"IO 1",100,64,5]
[null,null,null,null,null,240,"Expansion",100,20,2]
[null,null,null,null,null,302,"Switch 8 ports",100,27,4]
[null,null,null,null,null,302,"Switch 8 ports",100,27,4]
[null,null,null,null,null,174,"HDMI",50,19,1]
[null,null,null,null,null,{"$f":"H43+I43*$I$35+J43*$J$35","v":178},"USB 3.0",50,18,2]
[null,null,null,null,null,{"$f":"SUM(F37:F43)","v":1814},"Total 16 port switch + exp",null,{"$f":"SUM(I37:I43)","v":179}]
[null,null,null,null,null,{"$f":"F44-F41","v":1512},"Total 8 port switch + exp"]
[null,null,null,null,null,{"$f":"F44-F39","v":1574},"Total 16 port switch no exp"]
[null,null,null,null,null,{"$f":"F44-F39-F41","v":1272},"Total 8 port switch no exp"]

{"sheet":"Options","index":1,"n_rows":6,"n_cols":39,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["SBC","SBC","SBC","SBC","SBC","SBC","Operating system","OS","OS","OS","OS","OS","Ethernet switch","Switch","Switch","Switch","Switch","Switch","Switch firmware","Switch FW","Switch FW","Switch FW","Switch FW","Switch FW","Power supply","Power","Power","Power","Power","Power","Integrated mass storage","SSD","SSD","SSD","SSD","SSD","Expansion I/O","Expansion","Expansion"]
["Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","","",null,null,null,"Choose one:","",""]
["Venus 776KL-20","VNS776-20","i7-7600U CPU, 20GB RAM, ",1200,0.55000000000000004,{"$f":"ROUND(D3/(1-E3),0)","v":2667},"*Linux 64-bit","-LNX","Linux, ",75,0.5,{"$f":"ROUND(J3/(1-K3),0)","v":150},"8 Gbe copper ports","-EG8","8-Port Gbe Switch, ",191,0.55000000000000004,{"$f":"ROUND(P3/(1-Q3),0)","v":424},"Webstax Layer 2+","-L2","Layer 2+ FW, ",0,0.45,{"$f":"ROUND(V3/(1-W3),0)","v":0},"*MIL with isolation","-J","MIL Iso Power, ",964,0.5,{"$f":"ROUND(AB3/(1-AC3),0)","v":1928},"*1TB","1","1TB SSD",135,0.5,{"$f":"ROUND(AH3/(1-AI3),0)","v":270},"*My system has no additional I/O requirements","-01",""]
["Jasper 1185GRE-32","JSP1185-32","i7-1185GRE CPU, 32GB RAM, ",1827,0.45,{"$f":"ROUND(D4/(1-E4),0)","v":3322},"Windows 10 64-bit","-W10","Win 10, ",{"$f":"139+J3","v":214},0.5,{"$f":"ROUND(J4/(1-K4),0)","v":428},"16 Gbe copper ports","-EG16","16-Port Gbe Switch, ",505,0.5,1010,"No Ethernet switch","","",0,0.45,{"$f":"ROUND(V4/(1-W4),0)","v":0},"MIL without isolation","-N","MIL Power,",648,0.5,{"$f":"ROUND(AB4/(1-AC4),0)","v":1296},"2TB","2","2TB SSD",237,0.5,{"$f":"ROUND(AH4/(1-AI4),0)","v":474},"My system requires additional I/O (list below)","-XX (requires factory review)"," (requires factory review)"]
["Jasper 1185G7E-64","JSP1185G7E-64","i7-1185G7E CPU, 64GB RAM, ",1479,0.45,{"$f":"ROUND(D5/(1-E5),0)","v":2689},null,null,null,null,null,null,"No Ethernet switch","-EG0","No Ethernet Switch, ",0,0.5,0,null,null,null,null,null,null,"MIL-STD-461 filter","-F","1461 Filter, ",150,0.5,{"$f":"ROUND(AB5/(1-AC5),0)","v":300},"512GB","5","512GB SSD",76,0.5,152]
["Jasper 1365URE-64","JSP1365-64","i7-1365URE CPU, 64GB RAM, ",2285,0.45,4155,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"128GB","8","128GB SD",30,0.5,60]